SQL Query Analyzer

SQL Query Analyzer is a tool that allows graphic creation of queries and SQL scripts. It makes use of templates.

Microsoft SQL Server 2000 SQL Query Analyzer is a graphical tool that allows you to:

• Create queries and other SQL scripts and execute them against SQL Server databases. (Query window)

• Quickly create commonly used database objects from predefined scripts. (Templates)

• Quickly copy existing database objects. (Object Browser scripting feature)

• Execute stored procedures without knowing the parameters. (Object Browser procedure execution feature)

• Debug stored procedures. (T-SQL Debugger)

• Debug query performance problems. (Show Execution Plan, Show Server Trace, Show Client Statistics, Index Tuning Wizard)

• Locate objects within databases (object search feature), or view and work with objects. (Object Browser)

• Quickly insert, update, or delete rows in a table. (Open Table window)

• Create keyboard shortcuts for frequently used queries. (custom query shortcuts feature)

• Add frequently used commands to the Tools menu. (customized Tools menu feature)

You can run SQL Query Analyzer directly from the Start menu, or you run it from inside SQL Server Enterprise Manager. You can also run SQL Query Analyzer from the command prompt by executing the isqlw utility.^[1]

1. ^ http://msdn.microsoft.com/en-us/library/aa216945%28SQL.80%29.aspx